UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rzJKOezufCv5mTmf3tieDSvQyLmBUc24+zmA04jef28='
WHERE
key_id = '32510b1b9ea7807e06a9c6a4d1ad2e62a4d45540a6a155e27be01227bee7fea9'
AND (
token = 'rzJKOezufCv5mTmf3tieDSvQyLmBUc24+zmA04jef28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)