UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4o8HhjxhokKvit9EZIATgLun/4M8MVKAmfc8Zz9sL44='
WHERE
key_id = '57e5b9b6510f6927a233423b1b31c83ade28c8efa71485901ed1b5ce57998c4e'
AND (
token = '4o8HhjxhokKvit9EZIATgLun/4M8MVKAmfc8Zz9sL44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)