UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D1eJNT0wdKX6pP3ct8YK+BOws6pUZ+nh/AOV+ZgIXIg='
WHERE
key_id = 'ccd339e59ba52b39878a57925876b5b47190042647bfff9043d460d7bf942182'
AND (
token = 'D1eJNT0wdKX6pP3ct8YK+BOws6pUZ+nh/AOV+ZgIXIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)