UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C0iKoiYhkucNC8nlFR6gs58sdWc/aD6+fHGmZ9nUJRE='
WHERE
key_id = 'c93d37d45bcf29f7bf550fda6691ac6b87d790e419a4cf1630e4b8c2990ad015'
AND (
token = 'C0iKoiYhkucNC8nlFR6gs58sdWc/aD6+fHGmZ9nUJRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)