UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHy3XpEfr33oSwM8Y999o77w1xGgLv797o7PeoPy8Mw='
WHERE
key_id = '782c1e3e9991acdf622c1228ec190e191551675134c0b7e4b49333c38576b43c'
AND (
token = 'xHy3XpEfr33oSwM8Y999o77w1xGgLv797o7PeoPy8Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)