UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jm+eojQKJFvv5O6LHK19eZ8shHsS3Y8T2K4x4CJVTIY='
WHERE
key_id = 'f196e999ad74753c058bba3a43462ff579f6f03f9cbd515e152a68049e62143b'
AND (
token = 'jm+eojQKJFvv5O6LHK19eZ8shHsS3Y8T2K4x4CJVTIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)