UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's4W0L/VaUtj2oKqAWU+NfAsvCkP7155x7Aag27/sLL4='
WHERE
key_id = '8f6ac2f360a3e2996d98794523902c55c9fce2a6c9c0858782d03270c60303f0'
AND (
token = 's4W0L/VaUtj2oKqAWU+NfAsvCkP7155x7Aag27/sLL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)