UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C725eJPrW/8MMrbyCrL+1ZUA6fxuLm+ihEUB7zyP+Hs='
WHERE
key_id = '8ec0a6f49ff1c35ef748eb7bc1a6e533c310d82384affa7e94fe9d5d97b4f4c1'
AND (
token = 'C725eJPrW/8MMrbyCrL+1ZUA6fxuLm+ihEUB7zyP+Hs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)