UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gbGdgY50WwomNZDe/X4EH2A1DqrTuNy6adperarXFmw='
WHERE
key_id = 'a7dc2ac00622f1b7be0a8c80ffefc6bfa317f94bfd638f3fcdf7c4dcaafa1716'
AND (
token = 'gbGdgY50WwomNZDe/X4EH2A1DqrTuNy6adperarXFmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)