UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vavYxv9ek09mtGl00rWysfZMixV5zsgFsWHZkZDc5ls='
WHERE
key_id = '7611313abf989b6862521b358126e083c20d5e3c170592ada8718c18922ad46f'
AND (
token = 'vavYxv9ek09mtGl00rWysfZMixV5zsgFsWHZkZDc5ls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)