UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hctPz3kgObpV72LWouwInXGZKqlx+tmwEiUSiWr4RDY='
WHERE
key_id = '1617df4eaed7ecdc6c90204440f6abc7fb9b78835a6231c3dbf4053340087171'
AND (
token = 'hctPz3kgObpV72LWouwInXGZKqlx+tmwEiUSiWr4RDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)