UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tAvZJRv1ZxbZGecy0NPQ0oC45DKKj9QQGGT2rft7k68='
WHERE
key_id = 'a7fb1fc9ce75a57b5139f9568747240f1e0b3afba3f9b8e9687f70d81b4652a9'
AND (
token = 'tAvZJRv1ZxbZGecy0NPQ0oC45DKKj9QQGGT2rft7k68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)