UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W2OfrqONcqZRQecwcvdLDYPA32MKtKneCQONOuefuXo='
WHERE
key_id = '7406dd35d55b18513c5b9bd4a44cec14e145e0d4c6c9b1bd00472a9bfa61f9e2'
AND (
token = 'W2OfrqONcqZRQecwcvdLDYPA32MKtKneCQONOuefuXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)