UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RIRiy4GBVF8CyzkzMkiqfPStiMuFo0Wy6MkVEaM/PDk='
WHERE
key_id = 'ffdfa0f52c576abb8e7aaf2dc4d4797e996eba69fd4db3203424d226cdc6abc3'
AND (
token = 'RIRiy4GBVF8CyzkzMkiqfPStiMuFo0Wy6MkVEaM/PDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)