UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZJp+knJ/Qua310180xX2Mc9W5IlZznh4RJJwxSIvwrg='
WHERE
key_id = '1f4a03f4f4fcdcad12d0642eb5dab7f14352c872b5bb3fb2baef2cbb5a00f8b8'
AND (
token = 'ZJp+knJ/Qua310180xX2Mc9W5IlZznh4RJJwxSIvwrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)