UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ns58q2JUQ08rcv4cYDVI83sVq4BJkemYB919rV809ic='
WHERE
key_id = '2c7d3584593aa195b60124cd7edd16956cfe0cac9c1d032370584d72ba8317ab'
AND (
token = 'ns58q2JUQ08rcv4cYDVI83sVq4BJkemYB919rV809ic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)