UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vBpP2Qf0E2/fs1kLpGUWsBksAAOcrgRYjoFyehnN4tU='
WHERE
key_id = '2049c84bbfa1634bcc8025bdc035d75f9f1f9bd13b987ce6586a75f2c9312de2'
AND (
token = 'vBpP2Qf0E2/fs1kLpGUWsBksAAOcrgRYjoFyehnN4tU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)