UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3mQRt7YB1v6xLPjEf8jFW4BDmlev00ix4bzPXdh16gU='
WHERE
key_id = '589e0142481f0bbb993215c125336bfbcf2fab42a3c56e8e1591ae7e85737dce'
AND (
token = '3mQRt7YB1v6xLPjEf8jFW4BDmlev00ix4bzPXdh16gU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)