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