UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8jylgY3slAYp2iPRGI1bdLX5KqbkBmIXBn9O4Hs9M0='
WHERE
key_id = 'cc0a40caef23ca9f6420e1b303c407ed5e2615c1cddab945e5ecd350b2559f21'
AND (
token = 'J8jylgY3slAYp2iPRGI1bdLX5KqbkBmIXBn9O4Hs9M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)