UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q+8HrL4cggwkLGlfNvlL2T+hCmfr8BgirunZdtrzFMk='
WHERE
key_id = 'd86644688d105263acad6a4d0a8c7b202a3426cbcc55942bbfae1f99bbab26a2'
AND (
token = 'q+8HrL4cggwkLGlfNvlL2T+hCmfr8BgirunZdtrzFMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)