UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rd4/GsJb0K2B8r0TgRP8z3TxV0OScmwoLIejXA0tpGU='
WHERE
key_id = '300b2bc66850ce12baa19938b18a2038fb9ee0690b5ba0c9a5b5f10b30a4e14e'
AND (
token = 'Rd4/GsJb0K2B8r0TgRP8z3TxV0OScmwoLIejXA0tpGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)