UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zieVqlAYZr9O1IvPgDA5hkC3NGDGa6gw6Jd2xI0WoTQ='
WHERE
key_id = '8bb46298b3817b5edc4d7d093206cc07b057d39f0569300cd7fbfc1a649ad161'
AND (
token = 'zieVqlAYZr9O1IvPgDA5hkC3NGDGa6gw6Jd2xI0WoTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)