UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zYvN4aM/IbRZQM82dU4XB0AZqTmmABTCwavqG9UNxpI='
WHERE
key_id = 'd2ec060cc72121d9a652c51d2951e393952aa0061c081ca3363a580a1e2b6038'
AND (
token = 'zYvN4aM/IbRZQM82dU4XB0AZqTmmABTCwavqG9UNxpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)