UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bl7UVCdSaOOJboBcYaWfZ281/+TCRbXutunryMJUEek='
WHERE
key_id = 'd9e9396ebfc89c164ab4a09df53ad78a0004ddf1e7ba72c0b3a808948d4ffa0c'
AND (
token = 'Bl7UVCdSaOOJboBcYaWfZ281/+TCRbXutunryMJUEek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)