UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BDfasB3aEl9D0dP58yFPlL+IBJi8mPr6Zx8wI/wDGYE='
WHERE
key_id = 'f3c46302d0407e12bfaf39ef7b584c37f337c18114763f470611c96a0a93f023'
AND (
token = 'BDfasB3aEl9D0dP58yFPlL+IBJi8mPr6Zx8wI/wDGYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)