UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NA0IllWfjgRYCw6L40tJlxAsCsO5lXU/zrQljEEw9wI='
WHERE
key_id = '9e4cade464857e386ec54d36aa042f393ff7263a11497d9fec987cdeb73b5148'
AND (
token = 'NA0IllWfjgRYCw6L40tJlxAsCsO5lXU/zrQljEEw9wI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)