UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tZ/rQfRHkzkJopNvCzYi1A49MuH9GaR/dKJKSxRW4U4='
WHERE
key_id = 'b9af0a21365e5fe4423628af6afcd2f20a575b10e7a3a594d5f9d437665b0392'
AND (
token = 'tZ/rQfRHkzkJopNvCzYi1A49MuH9GaR/dKJKSxRW4U4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)