UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0cO3iuYr1xaakaemSkzGK+zuwmhfNK4OhlJ5+wnkRk4='
WHERE
key_id = '40cc9f778ef47dd7d5e1ecab3a3e9989f40fd86afd516506957e723d661adfbb'
AND (
token = '0cO3iuYr1xaakaemSkzGK+zuwmhfNK4OhlJ5+wnkRk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)