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